A case study in mapping conceptual designs to object-relational schemas

2000 ◽  
Vol 12 (9) ◽  
pp. 863-907 ◽  
Author(s):  
Susan D. Urban ◽  
Michael Tjahjadi ◽  
Jami J. Shah
Keyword(s):  
Relational Schemas ◽  
Conceptual Designs ◽  
Object Relational

scholarly journals Computer-Aided Clinical Trial Recruitment Based on Domain-Specific Language Translation: A Case Study of Retinopathy of Prematurity

2017 ◽  
Vol 2017 ◽  
pp. 1-9 ◽  
Author(s):  
Yinsheng Zhang ◽  
Guoming Zhang ◽  
Qian Shang
Keyword(s):  
Language Translation ◽  
Data Mapping ◽  
Database Queries ◽  
Healthcare Information Systems ◽  
Domain Specific ◽  
Database Administrator ◽  
Computer Aided ◽  
Object Relational ◽  
Data Source

Reusing the data from healthcare information systems can effectively facilitate clinical trials (CTs). How to select candidate patients eligible for CT recruitment criteria is a central task. Related work either depends on DBA (database administrator) to convert the recruitment criteria to native SQL queries or involves the data mapping between a standard ontology/information model and individual data source schema. This paper proposes an alternative computer-aided CT recruitment paradigm, based on syntax translation between different DSLs (domain-specific languages). In this paradigm, the CT recruitment criteria are first formally represented as production rules. The referenced rule variables are all from the underlying database schema. Then the production rule is translated to an intermediate query-oriented DSL (e.g., LINQ). Finally, the intermediate DSL is directly mapped to native database queries (e.g., SQL) automated by ORM (object-relational mapping).

scholarly journals Artificial Intelligence in Architectural Design

2021 ◽  
Vol 1 (1) ◽  
pp. 1-6
Author(s):  
A Harapan ◽  
◽  
D Indriani ◽  
N F Rizkiya ◽  
R M Azbi
Keyword(s):  
Artificial Intelligence ◽  
Architectural Design ◽  
Case Study Method ◽  
Great Responsibility ◽  
Conceptual Designs ◽  
Analyze Data

Artificial intelligence is one of the methods in elaborating design, especially on architectural design. This method has been adapted to many designs, such as building complex, massing models. This study aims to determine the influence of artificial intelligence in forming complex conceptual designs in architecture. We used a case study method by examining documents or journals related to research to conduct this research. The results show that more than 50% of artificial intelligence helps architects make conceptual designs. This is due to artificial intelligence's ability to analyze data and turn it into a draft plan. Then, it will be analyzed by the architect will so that they can make the final plan. However, there is still a bad influence that allows an architect to be replaced by automation. Therefore, that means artificial intelligence must be used with great responsibility.

Practical Case Study of a Web-Based Tutor Payment System

2003 ◽  
pp. 88-120
Author(s):  
Tanguy Chateau ◽  
Cecile Leroy ◽  
Johanna W. Rahayu ◽  
David Taniar
Keyword(s):  
Relational Databases ◽  
Web Applications ◽  
Traditional Approach ◽  
Practical Case ◽  
Development Phase ◽  
Practical Realization ◽  
Web Based ◽  
Web Technologies ◽  
Object Relational

The emerging use of object-relational databases with Web technologies has only recently begun. This chapter discusses a practical realization of an application using this technology. The aim is to show readers how to construct a full application from a design using object-oriented features up to the implementation. In this chapter, we highlight important or difficult stages with an emphasis on the mapping of object design into Oracle 8i and the use of stored procedures with the extended features for objects manipulation of Oracle 8i. This enables developers to construct professional Web applications achieving a high modularity and evolution capacity with an accelerated development phase in comparison with the traditional approach.

scholarly journals Database Private Security Jurisprudence: A Case Study using Oracle

2021 ◽  
Vol 13 (03) ◽  
pp. 01-21
Author(s):  
Madhuri N. Gedam ◽  
B. B. Meshram
Keyword(s):  
Security Policy ◽  
Real Life ◽  
Oracle Database ◽  
Fine Grained ◽  
Remote Server ◽  
Environment Variables ◽  
Database Encryption ◽  
Object Relational ◽  
Practical Guidelines

Oracle is one of the largest vendors and the best DBMS solution of Object Relational DBMS in the IT world. Oracle Database is one of the three market-leading database technologies, along with Microsoft SQL Server's Database and IBM's DB2. Hence in this paper, we have tried to answer the million-dollar question “What is user’s responsibility to harden the oracle database for its security?” This paper gives practical guidelines for hardening the oracle database, so that attacker will be prevented to get access into the database. The practical lookout for protecting TNS, Accessing Remote Server and Prevention, Accessing Files on Remote Server, Fetching Environment Variables, Privileges and Authorizations, Access Control, writing security policy, Database Encryption, Oracle Data Mask, Standard built in Auditing and Fine Grained Auditing (FGA) is illustrated with SQL syntax and executed with suitable real life examples and its output is tested and verified. This structured method acts as Data Invictus wall for the attacker and protect user’s database.

scholarly journals Performance Comparison of CRUD Methods using NET Object Relational Mappers: A Case Study

2020 ◽  
Vol 11 (1) ◽  
Author(s):  
Doina Zmaranda ◽  
Lucian-Laurentiu Pop-Fele ◽  
Cornelia Gyorödi ◽  
Robert Gyorödi ◽  
George Pecherle
Keyword(s):  
Performance Comparison ◽  
Object Relational

From Conceptual Models to Data Models

2011 ◽  
pp. 148-170 ◽  
Author(s):  
Antonio Badia
Keyword(s):  
Conceptual Model ◽  
Conceptual Models ◽  
Object Oriented ◽  
Data Models ◽  
Xml Database ◽  
Relational Schemas ◽  
Trade Offs ◽  
Object Relational ◽  
Entity Relationship ◽  
Entity Relationship Diagrams

This chapter describes transformations between conceptual models (mainly entity-relationship diagrams and also UML) and data models. It describes algorithms to transform a given conceptual model into a data model for a relational, object-relational, object-oriented and XML database. Some examples are used to illustrate the transformations. While some transformations are well known, some (like the transformation into XML or into object-relational schemas) have not been investigated in depth. The chapter shows that most of these transformations offer options which involve important trade-offs that database designers should be aware of.

scholarly journals A PROPOSAL FOR INTEGRATING DATA OF LAND REGISTRY AND URBAN CADASTRE

2018 ◽  
Vol 24 (4) ◽  
pp. 525-544
Author(s):  
Caio dos Anjos Paiva ◽  
Alzir Felippe Buffara Antunes ◽  
Silvana Camboim
Keyword(s):  
Open Source ◽  
Conceptual Model ◽  
Relational Database ◽  
National Level ◽  
Geospatial Data ◽  
Metropolitan Region ◽  
Land Registration ◽  
Exchange Of Information ◽  
Object Relational

Abstract It is noted a lack of integration between information of the Land Registration (LR) and of the Urban Cadastre in various Brazilian municipalities. Due to the lack of regulations at national level that define a conceptual model to organize the data from different entities, the design of integration systems geared to such a purpose is made difficult. Therefore, this study aims at developing an exchange prototype of the mentioned data from a previous research conducted by Paiva et al. (2016), concerning the modeling of the data resultant from LR and Urban Cadastre. To this end, we used the existing situation in the municipality of São José dos Pinhais, Curitiba metropolitan region, as a case study. There, the exchange of information between both entities is similar to that of many Brazilian municipalities. A conceptual model was generated and used to create an object-relational database, which then was used to develop an administrative and geospatial data consultation and editing prototype, based on technologies known as open-source. The use of such programs allowed us to verify the reproducibility possibility of the computational solutions referred herein to other cities with different economic situations.

The Genesis and Internal Dynamics of El Salvador's People's Revolutionary Army, 1970–1976

2014 ◽  
Vol 38 (01) ◽  
pp. 102-129
Author(s):  
ALBERTO MARTÍN ÁLVAREZ ◽  
EUDALD CORTINA ORERO
Keyword(s):  
Latin America ◽  
El Salvador ◽  
Early Years ◽  
Left Wing ◽  
Internal Dynamics ◽  
Internal Coherence ◽  
The 1960S

AbstractUsing interviews with former militants and previously unpublished documents, this article traces the genesis and internal dynamics of the Ejército Revolucionario del Pueblo (People's Revolutionary Army, ERP) in El Salvador during the early years of its existence (1970–6). This period was marked by the inability of the ERP to maintain internal coherence or any consensus on revolutionary strategy, which led to a series of splits and internal fights over control of the organisation. The evidence marshalled in this case study sheds new light on the origins of the armed Salvadorean Left and thus contributes to a wider understanding of the processes of formation and internal dynamics of armed left-wing groups that emerged from the 1960s onwards in Latin America.

Sign in / Sign up

Export Citation Format

Share Document